{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["DataSheet","Hidden Data","Help"],"not_rendered":{"images":4,"macros":1,"external_links":1,"defined_names":7,"comments":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"DataSheet","index":0,"n_rows":23,"n_cols":24,"rows_kept":23,"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["Id","TrustId","SubmissionId","MetaSubmissionId","Research Ethics Committee Reference Number","Integrated Research Application System Number","Name of Trial","Target Number Of Patients Agreed?","Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)","Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)","Target Date To Recruit Patients Agreed?","Date Agreed to recruit target number of patients","Total Number Of Patients Recruited At The Agreed Target Date","Date That The Trial Closed To Recruitment","Total Number Of Study Participants Recruited","Reason For Closure Of Trial","Comments","AddedByUserId","AmendedByUserId","DateAdded","DateAmended",null,"Errors","Check Rows to Delete on Upload Submission"]
[60229,1095,14409,89,"19/SC/0347",263849,"OPTINOSE","Number Agreed",10,10,"Not Available / Not Agreed",null,null,"2021-07-09",2,"Recruitment Finished","Recruitment effected by pandemic","Unknown","Unknown","2021-10-18","2022-07-20"]
[60230,1095,14409,89,"17/YH/0120",208838,"DISC","Number Agreed",72,72,"Not Available / Not Agreed",null,null,"2021-09-30",39,"Recruitment Finished",null,"Unknown","Unknown",{"v":44487,"d":"44,487.00"},"2022-07-20"]
[60231,1095,14409,89,"18/SW/0130",246372,"SUPRAFLEX","Number Agreed",100,100,"Not Available / Not Agreed",null,null,"2021-09-30",233,"Recruitment Finished",null,"Unknown","Unknown",{"v":44487,"d":"44,487.00"},"2022-07-20"]
[60232,1095,14409,89,"20/NI/0096",271885,"HIP HOP","Number Agreed",89,89,"Not Available / Not Agreed",null,null,"2021-10-08",68,"Recruitment Finished",null,"Unknown","Unknown",{"v":44575,"d":"44,575.00"},"2022-07-20"]
[60233,1095,14409,89,"18/YH/0013",214831,"DUAL ACS 2","Range Agreed",100,150,"Not Available / Not Agreed",null,null,"2021-11-04",26,"Withdrawn By Sponsor","Sponsor informed site: received notification from the British Heart Foundation that our extension request has been declined and the trial should be closed.","Unknown","Unknown",{"v":44575,"d":"44,575.00"},"2022-07-20"]
[60234,1095,14409,89,"19/LO/0933",251914,"PALIN","Range Agreed",1,8,"Not Available / Not Agreed",null,null,"2021-12-03",3,"Recruitment Finished","Please not there are two different recruitment groups, Children and Speech and Language Therapy. The former group as the target of 1 to 2 and The latter group has a target of 2 to 8","Unknown","Unknown",{"v":44575,"d":"44,575.00"},"2022-07-20"]
[60235,1095,14409,89,"17/SC/0506",216084,"HAPI","Number Agreed",70,70,"Not Available / Not Agreed",null,null,"2021-12-31",18,"Recruitment Finished",null,"Unknown","Unknown",{"v":44575,"d":"44,575.00"},"2022-07-20"]
[60236,1095,14409,89,"20/NE/0253",288479,"COVID NURSE","Number Agreed",40,40,"Not Available / Not Agreed",null,null,"2021-12-20",53,"Recruitment Finished",null,"Unknown","Unknown",{"v":44575,"d":"44,575.00"},"2022-07-20"]
[60237,1095,14409,89,"21/LO/0394",1003768,"OTONOMY - OTO 313","Range Agreed",1,1,"Not Available / Not Agreed",null,null,"2022-02-08",0,"Recruitment Finished",null,"Unknown","Unknown",{"v":44657,"d":"44,657.00"},"2022-07-20"]
[60238,1095,14409,89,"15/NW/0901",185797,"GAME READY","Number Agreed",100,100,"Not Available / Not Agreed",null,null,"2022-01-27",49,"Withdrawn By Sponsor","study had to close early due to some concerns regarding insufficient support to deliver the study and also the lack of funding.","Unknown","Unknown",{"v":44657,"d":"44,657.00"},"2022-07-20"]
[60239,1095,14409,89,"17/NW/0460",225455,"PEARL","Range Agreed",5,8,"Not Available / Not Agreed",null,null,"2021-09-09",1,"Withdrawn By Host","The oncology team have confirmed that they have struggled to recruit to this study, they have been experiencing difficulties with staffing levels and feel it would not be feasible to support this study further.","Unknown","Unknown",{"v":44657,"d":"44,657.00"},"2022-07-20"]
[60240,1095,14409,89,"16/NE/0238",204031,"SENIOR RITA","Range Agreed",3,5,"Not Available / Not Agreed",null,null,"2022-03-07",23,"Withdrawn By Host","Our recruitment not great since Covid . Team screens all the time . Cardiology PI and others are stenting a lot of the patients as they come in and don’t offer Senior Rita and make the clinical decision to perform Stent before the research nurse is aware .","Unknown","Unknown",{"v":44657,"d":"44,657.00"},"2022-07-20"]
[60241,1095,14409,89,"16/EE/0305",190307,"PRIMETIME","Range Agreed",50,75,"Not Available / Not Agreed",null,null,"2022-03-31",113,"Recruitment Finished",null,"Unknown","Unknown",{"v":44657,"d":"44,657.00"},"2022-07-20"]
[60242,1095,14409,89,"18/LO/0660",237150,"ATTUNE COMPLEX","Range Agreed",5,20,"Not Available / Not Agreed",null,null,"2022-04-29",2,"Withdrawn By Host","PI and delivery team closed at site early due to recruitment difficulties","Unknown","Unknown",{"v":44762,"d":"44,762.00"},"2022-07-20"]

{"sheet":"Hidden Data","index":1,"n_rows":18,"n_cols":42,"rows_kept":18,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"SpreadsheetOne - Hidden Data",{"$nulls":4},"01/07/2021","30/06/2022"]
[]
[null,"******** PLEASE DO NOT CHANGE ANY OF THESE VALUES ********"]
[]
[null,"Hidden Data Key","Hidden Data Value",null,"XML",null,"Class"]
[null,"Is First Open","FALSE",null,"<?xml version=\"1.0\" encoding=\"utf-16\"?>\r\n<DataTableDataExportContainerOfNewPerfDeliveryDetail xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n\t<DataTypeName>Exbos.Applications.NHSRBVP.Components.BusinessObjects.NewPerfDeliveryDetail, Exbos.Applications.NHSRBVP.Components.BusinessObjects, Version=1.0.10.0, Culture=neutral, PublicKeyToken=null</DataTypeName>\r\n\t<Site Id=\"1\" AddressId=\"-1\" StatusId=\"51\" TypeId=\"401\" CultureId=\"1\" AddedByUserId=\"1\" AmendedByUserId=\"1\" DateAdded=\"2013-06-15T22:56:16\" DateAmended=\"2013-06-15T22:56:16\">\r\n\t\t<Name>CTP Submission Platform</Name>\r\n\t\t<Description/>\r\n\t</Site>\r\n\t<MetaSubmission Id=\"89\" StatusId=\"2001\" TypeId=\"2103\" SubmissionRangeStartDate=\"2021-07-01T00:00:00\" SubmissionRangeEndDate=\"2022-06-30T00:00:00\" SubmissionOpenDate=\"2022-07-01T00:00:00\" SubmissionWarningDate=\"2022-07-15T00:00:00\" SubmissionDeadlineDate=\"2022-07-29T00:00:00\" AddedByUserId=\"250\" AmendedByUserId=\"250\" DateAdded=\"2022-07-01T08:51:21\" DateAmended=\"2022-07-01T08:51:21\">\r\n\t\t<Name>Q1 22-23 PD</Name>\r\n\t</MetaSubmission>\r\n</DataTableDataExportContainerOfNewPerfDeliveryDetail>\r\n",null,"NewPerfDeliveryDetail"]
[null,"Development Mode","FALSE"]
[null,"Data Id",{"v":14409,"d":"14409.00"}]
[null,"User Id",{"v":-1,"d":"-1.00"}]
[null,"Data Id",{"v":40,"d":"40.00"}]
["<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>1</Order>\r\n\t<Name>Id</Name>\r\n\t<FriendlyName>Id</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>true</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>2</Order>\r\n\t<Name>TrustId</Name>\r\n\t<FriendlyName>TrustId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">1095</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>3</Order>\r\n\t<Name>SubmissionId</Name>\r\n\t<FriendlyName>SubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">14409</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>4</Order>\r\n\t<Name>MetaSubmissionId</Name>\r\n\t<FriendlyName>MetaSubmissionId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">89</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>5</Order>\r\n\t<Name>ReferenceNumber</Name>\r\n\t<FriendlyName>Research Ethics Committee Reference Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>6</Order>\r\n\t<Name>IntegratedResearchNumber</Name>\r\n\t<FriendlyName>Integrated Research Application System Number</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>20</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>NotEmpty</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>7</Order>\r\n\t<Name>TrialName</Name>\r\n\t<FriendlyName>Name of Trial</FriendlyName>\r\n\t<UseTextArea>true</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>2000</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>8</Order>\r\n\t<Name>TargetTypeAgreedId</Name>\r\n\t<FriendlyName>Target Number Of Patients Agreed?</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2500</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2501</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Not Available / Not Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2502</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Number Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2503</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Range Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>9</Order>\r\n\t<Name>MinimumTargetValue</Name>\r\n\t<FriendlyName>Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>10</Order>\r\n\t<Name>MaximumTargetValue</Name>\r\n\t<FriendlyName>Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>11</Order>\r\n\t<Name>TargetDateAgreedTypeId</Name>\r\n\t<FriendlyName>Target Date To Recruit Patients Agreed?</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2600</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2601</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Not Available / Not Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2602</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Date Agreed</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>12</Order>\r\n\t<Name>TargetDate</Name>\r\n\t<FriendlyName>Date Agreed to recruit target number of patients</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>true</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>13</Order>\r\n\t<Name>TotalPatientsRecruited</Name>\r\n\t<FriendlyName>Total Number Of Patients Recruited At The Agreed Target Date</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Date</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>14</Order>\r\n\t<Name>RecruitmentClosedDate</Name>\r\n\t<FriendlyName>Date That The Trial Closed To Recruitment</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">1753-01-01T12:00:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>Integer</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>15</Order>\r\n\t<Name>NumberParticipantsRecruited</Name>\r\n\t<FriendlyName>Total Number Of Study Participants Recruited</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-99999911</DefaultValue>\r\n\t<UseCustomErrorValidator>true</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>16</Order>\r\n\t<Name>ClosureReasonTypeId</Name>\r\n\t<FriendlyName>Reason For Closure Of Trial</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>2700</DataTypeId>\r\n\t<DataType>Type</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2701</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Recruitment Finished</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2702</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Withdrawn By Sponsor</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>2703</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Withdrawn By Host</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>String</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>true</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>17</Order>\r\n\t<Name>Comments</Name>\r\n\t<FriendlyName>Comments</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>500</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:string\"/>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>18</Order>\r\n\t<Name>AddedByUserId</Name>\r\n\t<FriendlyName>AddedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>209</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>Int32</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>19</Order>\r\n\t<Name>AmendedByUserId</Name>\r\n\t<FriendlyName>AmendedByUserId</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>Site</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache>\r\n\t\t<item>\r\n\t\t\t<key>\r\n\t\t\t\t<int>209</int>\r\n\t\t\t</key>\r\n\t\t\t<value>\r\n\t\t\t\t<string>Unknown</string>\r\n\t\t\t</value>\r\n\t\t</item>\r\n\t</DataTypeCache>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:int\">-1</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>20</Order>\r\n\t<Name>DateAdded</Name>\r\n\t<FriendlyName>DateAdded</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2022-07-20T11:20:29.723+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>",null,"<ColumnSettings>\r\n\t<PropertyTypeString>DateTime</PropertyTypeString>\r\n\t<WarningValidationRule>None</WarningValidationRule>\r\n\t<ErrorValidationRule>None</ErrorValidationRule>\r\n\t<Visible>false</Visible>\r\n\t<CanBeEmpty>false</CanBeEmpty>\r\n\t<DoNotAutoLoadCache>false</DoNotAutoLoadCache>\r\n\t<Order>21</Order>\r\n\t<Name>DateAmended</Name>\r\n\t<FriendlyName>DateAmended</FriendlyName>\r\n\t<UseTextArea>false</UseTextArea>\r\n\t<DataTypeId>-1</DataTypeId>\r\n\t<DataType>None</DataType>\r\n\t<MaxLength>-1</MaxLength>\r\n\t<DataTypeCache/>\r\n\t<IncludePleaseSelect>true</IncludePleaseSelect>\r\n\t<PleaseSelectIsError>true</PleaseSelectIsError>\r\n\t<ReadOnly>false</ReadOnly>\r\n\t<DefaultValue xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"xsd:dateTime\">2022-07-20T11:20:29.723+01:00</DefaultValue>\r\n\t<UseCustomErrorValidator>false</UseCustomErrorValidator>\r\n\t<UseCustomWarningValidator>false</UseCustomWarningValidator>\r\n\t<UseCustomValueCalulator>false</UseCustomValueCalulator>\r\n</ColumnSettings>"]
["Id",null,"TrustId",null,"SubmissionId",null,"MetaSubmissionId",null,"Research Ethics Committee Reference Number",null,"Integrated Research Application System Number",null,"Name of Trial",null,"Target Number Of Patients Agreed?",null,"Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number)",null,"Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number)",null,"Target Date To Recruit Patients Agreed?",null,"Date Agreed to recruit target number of patients",null,"Total Number Of Patients Recruited At The Agreed Target Date",null,"Date That The Trial Closed To Recruitment",null,"Total Number Of Study Participants Recruited",null,"Reason For Closure Of Trial",null,"Comments",null,"AddedByUserId",null,"AmendedByUserId",null,"DateAdded",null,"DateAmended"]
["Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value","Id","Value"]
["blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2501,"Not Available / Not Agreed","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2601,"Not Available / Not Agreed","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#",2701,"Recruitment Finished","blank£%X_@#","blank£%X_@#",209,"Unknown",209,"Unknown","blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#"]
[{"$nulls":14},2502,"Number Agreed",{"$nulls":4},2602,"Date Agreed",{"$nulls":8},2702,"Withdrawn By Sponsor",null,null,"blank£%X_@#","blank£%X_@#","blank£%X_@#","blank£%X_@#"]
[{"$nulls":14},2503,"Range Agreed",{"$nulls":4},"blank£%X_@#","blank£%X_@#",{"$nulls":8},2703,"Withdrawn By Host"]
[{"$nulls":14},"blank£%X_@#","blank£%X_@#",{"$nulls":14},"blank£%X_@#","blank£%X_@#"]

{"sheet":"Help","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[null," Spreadsheet Help"]